select distinct a.matricule,libressource1,libressource2,datpla,plage,a.typjrs,a.hrsdeb,a.hrsfin,a.codposte,libposte,b.col01                          
                          FROM postpla a, poste b, rcressource c, RCMOUVNT mov where a.matricule=c.matricule and a.codposte=b.codposte and a.matricule = mov.matricule                        
                          and b.col01 = 'GM'
                          and mov.DATOUT >= to_date('2016-09-09', 'YYYY-MM-DD')
                          and datpla = to_date('2016-09-09', 'YYYY-MM-DD')
                          and plage =1;
                          